select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and a.houseType = 3 and (b.cnpropertyname like '%Old house in YanAn Road%' or b.enpropertyname like '%Old house in YanAn Road%') order by updateTime Desc, a.dftpic desc
T: +86-21-6333-0390, M: +86-185-1609-7608
Home > All for rent > Properties 1 to 7 of 7
Totle: 7 Properties
  • Old house in YanAn Road
  • ¥ 33,000/month
  • Layout: 3Br 2Bt
  • Size: 160 sqm
  • 3/2/2,160 Sqm cozy Lane house with a huge dinning room,35 Sqm yard,full furnished with whole wall heating,55 inch LCTV,SAMSUNG washing machine with dryer,refr...
  • Old house in YanAn Road
  • ¥ 21,800/month
  • Layout: 3Br 2Bt
  • Size: 120 sqm
  • Delicated decoration,full furnished,whole house wall heating
  • Old house in YanAn Road
  • ¥ 36,000/month
  • Layout: 3Br 2Bt
  • Size: 180 sqm
  • Located in busy streets, Hiding in a 30s Shanghai historical alley. This recently renovated three bedroom paradise has an easy access to the subway, shopping, ...
  • Old house in YanAn Road
  • ¥ 15,000/month
  • Layout: 3Br 1Bt
  • Size: 136 sqm
  • Newly renovated, full furnished, with 3 balconies.
  • Old house in YanAn Road
  • ¥ 26,000/month
  • Layout: 3+1Br 2Bt
  • Size: 180 sqm
  • duplex layout, luxury deco with spacious and bright livingroom,with a beauty balcony,40sqm terrace and 100sqm patio,nice view.
  • Old house in YanAn Road
  • ¥ 18,000/month
  • Layout: 3Br 2Bt
  • Size: 160 sqm
  • Nice western decoration with two big balconies,once big walking closet.
My dashboard
  • This is your property dashboard...
  • Recently viewed properties and searches will appear here for quicker reference.
Call (+86-21)6333 0390 to get more information,or Online Request
  1. About Us
    Why Michael Realty
    About Michael Realty
    Careers
    Contact Us
  2. Property Guides
    Yanlord Garden
    Shimao Riviera Garden
    IFC
    Central Residence
    Casa Lakeville
    Ladoll International City
    The Greenhills
  3. Links
    FAQ
    Mandarin Inn
    Immigration
    Healthcare
    Utility bill & Maid
    Others
Copyright © 2014 Michael Realty All Rights Reserved. 沪ICP备14038152号